SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809911 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809911 [ RunTime:0.004257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4189,573262,430994,191814,524787,552255,369976,555624,403200,813799,78808,615879,21900,988159,504470,43920,610272,594305,612712,696175,485485,311611,324471,328081,266390,49836,942885,828204,977064,9184,539725,189044,114589,1048333,321865,659549,822157,453852,554954,832856,806963,472274,342534,175840,419171,943936,243643,603434,50983,770624,885944,922299,455651,195819,836170,360716,8585,810392,263685,969021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001838s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]