SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170683 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170683 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528800,52543,91579,830094,228608,711869,793309,1043461,388978,111271,184713,393544,223324,522570,340733,474985,364777,873726,700705,270224,943243,1007577,219838,570572,338247,220305,126986,594822,341203,706411,431918,864202,883643,1010080,267940,74831,310913,271625,337570,496002,304189,1042018,185912,253403,822473,858335,997655,503361,973488,361626,570397,51282,97476,166330,683342,21562,909871,278901,69269,353449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]