SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519291 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519291 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459021,8544,846269,516116,71962,797585,98524,62601,347634,646108,369551,401757,929139,860056,104367,585211,732720,984701,316048,12919,1002728,158812,893062,720549,792437,53571,174724,287433,753328,184712,191965,464888,548046,397275,326734,388221,93525,988061,403205,98819,270769,393878,309052,350121,1003158,817345,851540,594253,759910,828137,936592,561116,911691,398028,757391,364655,761898,745945,1004419,128851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]