SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014805 LIMIT 1 [ RunTime:0.002378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014805 [ RunTime:0.007105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472740,688094,478092,448846,537576,178123,328567,377454,923251,901621,535967,12358,833816,157207,137943,293849,214251,449423,1042127,77489,262567,763440,141210,577027,909607,855075,367696,894068,250458,104488,672947,906010,1263,283797,346341,304696,496073,570610,85449,213666,658155,653843,967588,784546,344624,416526,82267,537948,612959,323162,381045,673835,146070,613820,698402,381856,399544,252219,456310,845857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]