SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586797 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586797 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043940,822994,152382,709968,509549,52950,524035,45457,928933,48155,522571,235750,48267,957555,1037169,806003,84662,757164,940406,923431,1004394,323431,863263,421190,239899,385674,309169,102846,554035,770850,655244,378261,444868,30244,799332,56377,467836,486173,296316,51739,545141,867360,269299,578415,132355,171180,932202,497730,551930,900984,441926,89546,198389,935527,647619,773988,731683,954031,785690,627107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]