SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566840 LIMIT 1 [ RunTime:0.003147s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566840 [ RunTime:0.003594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402095,819657,540892,276739,542722,323617,205634,1021935,912855,325211,523069,682351,15423,39677,954783,752023,427181,164134,614180,925652,936876,717102,90109,172798,111541,212195,561246,863438,543763,376853,181370,220102,636589,19149,704311,761961,981965,397033,439246,932211,647300,647,500335,9972,308530,225257,131625,21408,262627,262799,698873,1014607,525761,608343,179942,537697,465102,868048,450590,1027363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001337s ]