SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547871 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547871 [ RunTime:0.003383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936272,314787,507694,7980,572917,440816,293042,709930,747899,641442,426294,279713,73150,803765,281937,665755,476091,104124,147965,517973,447961,738114,769959,78964,369406,418794,766379,216588,423463,242705,261059,683715,248588,647045,600740,456942,806466,994722,197705,106507,910420,460820,715541,426982,545302,487707,346351,822239,711123,929573,182529,604150,1010212,31808,113905,1020406,631025,539891,936597,63969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]