SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437515 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437515 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575799,471185,972478,844336,455077,237447,604848,347315,10563,176478,243107,217825,161413,736448,679315,240433,495199,87834,950910,1040600,587453,30313,759875,367040,427488,289964,811035,437595,651558,978946,743744,367890,593861,301083,776558,407975,744500,546670,498597,476722,410856,802796,629285,181017,240702,280371,327629,493637,701342,720442,661449,377863,723445,46423,700367,950584,423302,570924,245354,17629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]