SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 798431 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 798431 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600963,663822,552468,309383,813186,901323,243189,447291,988804,479032,585174,333751,981191,554260,99056,736168,107008,855018,411427,68582,685215,473884,227967,436693,151111,153410,1000992,1032072,538403,1008506,115660,990718,1033832,423996,400912,707577,971685,856749,1001297,255429,281201,1020798,232615,713921,391808,908219,899528,351030,772914,535978,659096,329289,981852,476260,1022887,338301,369283,748134,915345,261354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 798431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 798431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]