SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686245 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686245 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508802,93578,850684,613144,106003,877972,406916,784476,135735,279398,394820,260153,932648,769870,1023205,658738,501933,569286,751106,770212,944651,893032,620242,1018839,677789,487882,1001394,268639,201801,799742,6146,2036,230269,968669,14148,680037,918002,248387,373443,18405,231689,111898,149254,111246,377821,671777,1007096,326005,958923,308371,602828,218489,88648,890207,800508,1013867,696335,801117,180052,544280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001484s ]