SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599797 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599797 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155343,254555,384383,798131,457295,481240,875535,1018306,573727,359776,961275,768014,949264,448351,108488,281795,695564,470353,645877,916868,414350,223954,623787,855453,560095,196333,729881,704138,227915,833906,421832,904408,155165,369798,904381,976638,464267,198130,697551,628879,688726,39512,1014159,697603,877175,939294,309898,645006,635942,670245,723239,737424,340230,1042550,851865,606130,592053,279901,1047170,895681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]