SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040240 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040240 [ RunTime:0.003826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117946,759734,940839,483865,873958,700554,720074,398156,43718,71263,59552,504753,927942,939141,677370,719891,213361,427448,645424,506679,83488,1018175,886994,276321,595315,147727,949902,882762,225208,658794,450446,870689,809164,643040,305300,344253,192270,767309,912556,332170,531579,716362,747170,227313,567943,15353,850475,326639,448985,632151,125520,697040,468633,933873,877407,226427,1047712,928398,647059,873739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]