SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418651 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418651 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206329,331244,509330,844592,287338,163340,954372,247160,82949,544400,752657,655667,312323,927561,409966,884464,1032916,236996,672173,396290,112015,938098,57007,492282,656980,595641,763394,59928,54952,861423,497380,303986,210679,371080,110350,260078,354013,576627,393242,657609,502779,407821,1012342,211686,1002702,952616,603934,58551,46138,948806,128864,619979,917405,352463,800320,167906,234279,1037991,975839,871111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]