SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 138694 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 138694 [ RunTime:0.003415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722668,590324,837510,856727,283013,910150,204112,809236,725101,923495,565818,266871,804516,1045840,690885,932616,5506,39535,628118,914915,773286,133142,129959,853013,786814,111948,789105,718487,847391,200332,340108,1011426,267861,649493,723423,313081,953549,581431,838853,722645,635371,296275,677219,1043889,964299,723618,957456,992175,175264,120719,317574,62003,279117,16758,108900,618405,847282,506883,575067,844820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 138694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 138694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]