SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514701 LIMIT 1 [ RunTime:0.001862s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514701 [ RunTime:0.004821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197360,569827,459110,857757,428376,578986,401815,1042282,567958,470134,839129,113066,787425,219794,400488,210210,467728,627772,480759,274807,309917,226667,661526,636402,284255,703350,95625,980659,531031,275877,45162,580871,589530,108061,157009,271133,1018139,413863,890783,1040113,367033,67539,719772,13210,421255,98340,225921,734030,570039,257716,742484,965334,409483,569651,375698,355976,226872,970517,133692,137647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]