SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004748s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 742910 LIMIT 1 [ RunTime:0.005669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 742910 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394856,592327,1045772,430911,330247,769665,510363,500231,843368,986633,539022,860712,239318,844458,634258,335350,1039353,541296,772629,147493,933475,774227,352190,475192,550888,852355,727014,238605,352750,392314,584626,302805,268116,1018604,651240,828074,373,291469,476009,111986,1037600,841573,317447,200819,573137,864580,1017940,994864,805160,533163,572466,786100,909410,409829,393530,594101,806555,948034,274962,192043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 742910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 742910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]