SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404539 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404539 [ RunTime:0.003365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700737,672388,1016834,1033162,7362,155151,257895,677124,356127,602337,159971,641922,18728,883265,260922,825929,105571,184150,256932,309908,399674,400219,679312,531567,597510,991403,197581,292093,651977,276055,9684,798291,398996,397416,31280,247411,356877,167591,442813,963647,973337,57912,647621,506973,625810,576623,872379,1039898,694233,687418,208351,877819,591526,673989,1015545,1033548,283110,630276,825078,727393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]