SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420098 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420098 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397283,666196,883901,678406,163712,306649,235374,179519,77793,782067,591617,688039,85196,282843,280184,211754,550396,507874,623588,870115,137560,145597,319536,260187,531225,517909,770257,660438,1023596,640074,660673,343356,358879,610508,265583,125502,689784,359003,44540,632550,795766,484522,762208,253314,773656,463126,676609,713280,944599,138570,780301,806799,324047,465159,612495,206747,1039796,908270,200786,228949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]