SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479451 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479451 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507746,284512,1034665,730642,89785,679153,51730,1024044,824871,735025,914626,204726,90723,536247,526822,857905,312411,87908,593428,404449,547362,455651,513062,502262,784376,164203,755365,236933,808327,938635,857238,235382,575971,260964,173425,591300,183804,632213,98084,43286,324464,377901,1043032,417735,721458,188813,331507,515611,657447,981560,673206,512731,317917,277094,357621,339089,136436,329840,805921,1000451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]