SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200492 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200492 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169495,546807,704206,98616,772060,220791,62880,321522,765229,542794,90515,588785,1009903,660592,459949,266020,505012,525405,729016,562234,370330,82944,373044,998897,602330,811616,607738,79133,836638,694836,458422,312167,896264,665524,265520,684225,189710,384306,351402,367689,360253,525386,573100,574269,927894,919066,667654,784104,728431,65662,942645,407392,932215,69897,753935,776186,41770,725325,339039,301238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200492 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200492 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]