SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310261 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310261 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911081,349014,434625,968870,296983,800284,701341,807587,308679,86868,304486,118049,221431,461124,672540,1023080,136808,791195,829162,101926,65998,124191,994353,1042805,307264,531385,616208,217338,135653,119906,931864,33477,1004789,875970,351388,808247,587656,59190,461078,295191,730278,51829,28344,1021186,42831,825938,442277,293391,663995,235057,74197,915846,95977,644095,269656,160355,55563,403257,820047,795586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]