SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400218 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400218 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980232,44507,416731,818415,609908,113842,266534,286230,89534,803116,686801,137827,993945,128809,862056,1017337,847931,970801,875299,188327,703936,959928,41020,480812,987328,185552,991379,797228,816016,930171,544296,585647,982396,231967,392620,491532,492630,1028968,823652,313340,702594,207619,500448,121371,995294,1008438,46322,106792,643835,794256,487420,465358,212764,623108,668898,307331,98382,954986,281399,565539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]