SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410929 LIMIT 1 [ RunTime:0.001316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410929 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512339,804055,402915,946822,201715,600477,201175,95916,432615,67512,189583,970478,559545,784016,53050,744209,402663,1022174,409547,717589,249789,248035,133062,939237,83157,716535,366305,58994,177672,223290,782877,390632,576497,592341,857247,218284,859424,696383,1022837,535050,169266,82886,158496,220275,834753,46077,947691,175515,827102,366319,401598,122292,330281,1037451,262004,226203,680343,961742,671104,762593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001000s ]