SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451409 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451409 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390038,555454,276964,662003,748755,116369,2562,83995,895546,198054,919693,1016357,571650,839773,74100,584831,232302,629480,229784,1014437,555644,428229,265634,210021,118630,1012386,94637,91407,845357,569691,310444,193445,114639,763904,802638,16349,112909,279188,1179,1018803,673955,147756,963813,748938,595368,132881,494548,837484,636326,70391,19426,903180,124098,372228,917754,427554,595177,265149,538643,992995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]