SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002926 LIMIT 1 [ RunTime:0.002565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002926 [ RunTime:0.003121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501519,27732,157915,229683,782109,352383,145835,40574,648060,270557,233016,444401,367129,310547,798753,730823,517940,210103,451726,248006,600722,121003,586615,60719,292331,496455,135797,294762,562044,963411,971575,469654,268657,192078,892657,796808,904947,722555,721953,266417,916452,937488,559973,947398,40603,958520,137889,901018,624871,631752,200943,808880,623349,914760,864795,88879,962037,633242,538715,348417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002268s ]