SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507511 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507511 [ RunTime:0.002645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382339,691559,375768,133989,142962,82764,878790,425268,12709,408283,359707,345485,268805,13618,800984,736894,241286,784179,103365,430934,483428,159706,5241,652091,514753,455026,88417,710411,1040972,50266,83593,452783,35769,659900,253882,258648,177862,717932,964734,333314,298211,677965,616319,460191,67285,583883,1039586,664365,290504,549351,473199,889158,942865,194231,481281,629659,894106,762641,598803,492451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]