SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40911 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40911 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210460,249953,873800,554613,181092,217265,481852,1040268,732990,809658,95632,227787,462172,1018367,628323,462126,185647,304356,370740,376000,532988,581119,336109,5149,630747,307763,240654,617554,1010313,362000,74657,226451,1006060,136862,864314,661421,463280,295487,398793,49060,254449,651018,606716,806547,507929,952020,29301,114674,178437,662253,921982,156129,231933,688701,182061,933334,660158,700141,602096,199680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001954s ]