SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547943 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547943 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719179,260281,145989,387416,578517,309848,470577,22587,441325,868542,683906,778560,988615,436816,255611,850193,680357,843492,855584,195426,985216,592154,294407,49024,696309,387914,675131,292408,10183,1042759,501864,143749,971849,415640,73199,737703,906829,595756,684564,159731,649573,645536,640012,411872,158962,906121,101517,783589,401120,268082,775741,1008087,497088,294210,661114,408838,211337,996962,198229,465374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]