SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580838 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580838 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553541,967103,1015083,783481,644482,317976,468422,995003,316489,460726,579922,830181,417304,1011604,542266,442525,337744,214969,476244,33085,799255,425163,252120,613112,87385,220532,959640,372466,387699,350123,543209,123057,417125,399435,782920,356337,1040165,432334,978423,669418,148880,67850,143809,115843,362141,80523,446933,285472,452835,478424,1019599,566202,567122,199318,468738,794222,978099,209512,902559,535847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]