SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001088 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001088 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382346,245838,330809,1010949,433676,5894,251463,914294,441729,1042969,668832,342370,963350,815495,297316,648495,293259,27632,631190,579379,555473,537596,915382,158137,604314,487568,410312,640788,910756,948755,902214,640669,289804,780477,1043940,67776,135291,925287,244779,6179,968733,636904,703212,1023335,495408,859966,62400,983711,577510,25864,150806,998005,601694,372218,249213,171036,247499,677334,643349,391100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]