SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916343 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916343 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230890,953573,515055,501108,547941,981485,1020774,301581,1035290,688457,983406,40454,306507,841869,533260,143569,96646,809560,403098,103724,624680,533905,940998,861915,696089,252008,385193,650505,894804,257738,403268,971117,257289,1031107,427946,763820,342926,787471,238841,404121,724338,995139,800986,897718,851985,527604,975755,417247,740479,80587,995006,44090,777254,802021,676182,81546,496305,703274,685069,582822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]