SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447978 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447978 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922991,1017894,424746,800652,54807,185506,464607,701145,442408,308761,2338,436933,179163,857108,571060,214161,286247,158901,456116,437082,54415,356580,98608,352010,864925,438089,12590,595496,71034,365803,868823,506246,742614,727469,197389,665385,991204,133372,173033,782719,506782,844431,278943,58384,522436,161271,106049,643346,643045,415268,976669,942559,705394,344799,154119,479529,176216,1011373,713616,611373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]