SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541521 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541521 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320835,391024,223710,1014680,343677,727600,986995,68183,633365,859057,966341,26378,125416,395226,424028,498056,105390,875315,424647,710268,509669,1036372,72618,881013,552762,632797,155136,673333,74539,260562,141358,606839,644077,799128,63136,27613,632831,851744,400026,69268,23832,778505,5313,196662,85723,698985,845891,751311,903346,506247,17701,878473,172899,395771,651192,60809,280129,737033,448240,504798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]