SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512078 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512078 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331172,798534,270857,421296,690401,378535,1005061,502217,329703,635359,73190,732976,44385,654746,793150,59530,1021510,886271,1019658,234763,1002060,800350,288252,1032849,673805,798741,890053,76913,406791,232216,739380,490061,378085,564398,827398,38744,695199,491129,185734,25976,539080,742544,425596,98620,414689,217698,191689,341709,744100,770227,109649,935444,986445,582998,359752,310100,74019,418323,926906,131712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]