SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409240 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409240 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10860,1005156,275566,892085,188027,33941,290449,830380,694459,975350,874958,518178,514941,578914,877510,725775,179614,757196,144292,738472,67461,434779,828547,282959,338864,424692,6912,556760,806950,557624,3716,160740,521907,970028,321675,693107,673924,517031,759555,568676,1040989,985984,438725,502762,725375,503798,499903,525735,195173,450926,7693,198845,40928,975297,901826,343754,283045,939992,186600,312663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002040s ]