SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450143 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450143 [ RunTime:0.002724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012361,220835,349300,160190,577190,668193,401396,1036494,378986,743556,496167,416826,467515,1001169,735724,576065,455965,942742,713090,108261,539207,850684,167540,776162,131758,851022,320312,498082,205880,680664,11628,584293,153962,848990,603120,981723,777736,435291,1006314,914768,864162,963820,733547,810820,1042149,438768,139580,598461,850301,1032763,537391,129467,791403,784023,757901,706641,157706,1038812,447859,978520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]