SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512681 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512681 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122536,198286,676335,403857,631863,31232,116162,182138,516951,443764,664846,541433,1028243,758654,946457,10713,826771,605485,898160,697746,392712,67828,31567,921706,1028661,446559,676028,8002,123151,820768,587378,640306,82656,513487,91255,37771,463211,923397,223838,22362,704667,396708,902856,883844,899720,695444,628036,442231,623725,930117,87603,731743,194212,906819,473468,133338,758370,186311,572175,269892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]