SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041040 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041040 [ RunTime:0.002837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96703,125759,258674,224080,1023715,1008297,980728,870373,688723,727618,721517,408017,729115,522311,77104,432718,549696,40205,692600,192544,1005401,147150,3355,945584,392283,951958,73619,1045698,260825,884241,335456,700890,744784,581739,1023525,219407,285744,484320,345750,249881,75106,71285,987702,959808,993621,610465,331221,219810,691626,534976,832744,591728,218950,248567,960765,505470,841382,835543,368070,994365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]