SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579482 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579482 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105604,959222,701935,795979,712963,600528,745105,803103,137792,571545,881190,123370,429060,407834,759687,258794,114040,138756,879722,811554,279913,102055,960302,73089,889728,846622,984896,45894,489384,1047679,486546,1031103,526392,631194,525978,120107,1036227,594702,961515,799377,640987,903982,449427,208870,838400,387409,727101,208928,773631,677986,98873,760784,341015,449066,237502,960566,552861,875909,167343,1045283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]