SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531215 LIMIT 1 [ RunTime:0.003676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531215 [ RunTime:0.003511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928029,805194,396755,246309,977553,935920,4459,636546,986432,677383,973937,246982,369584,502257,211989,443806,402597,136721,884786,177593,864192,312060,367657,153094,73169,904290,533237,550620,44126,653212,440070,952097,985451,358447,578081,509356,584696,408842,986324,373293,285402,947904,651709,648805,1004452,79089,331046,800588,905697,18487,373334,850818,477283,901673,945254,633044,129574,256719,451632,664144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]