SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 846208 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 846208 [ RunTime:0.002620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443284,785067,694422,194450,550184,417655,651726,583758,283774,223906,149140,68295,982145,605498,27849,40677,328402,659748,109124,303600,364147,1016395,391918,18133,269536,434552,883578,154748,416057,420471,237155,667274,276860,33991,285011,545651,441821,841758,365010,244885,786393,889236,867102,112267,680118,401909,330888,43452,595550,536687,1037042,1044504,611870,658607,784987,919930,209533,966581,494492,839444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 846208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 846208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001280s ]