SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504222 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504222 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971934,170470,768626,116334,711516,352643,433625,285959,793297,170976,140916,978775,654592,764541,636562,214007,676216,458282,224291,151447,986960,723621,876313,1029222,637558,511591,159413,680545,210982,344092,404960,809723,191599,135137,298715,1012343,84645,445536,299307,806473,678737,549859,233955,983453,364884,467979,301868,207656,524921,553827,756623,884111,930032,601378,98162,38460,542312,586845,582666,725482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]