SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482425 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482425 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445617,511632,92545,648431,1016220,680496,306585,831090,967621,739308,411509,515581,25901,792255,521103,135425,971618,974670,337035,721492,680395,157056,436557,499490,626057,619397,480825,852600,322182,584276,521829,887201,1010090,729891,173484,576651,892563,462594,582067,247869,594599,279794,492559,409750,465517,284754,144340,986061,264176,509924,1040226,339635,493633,988936,813593,535205,70294,547030,57110,839671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]