SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047119 LIMIT 1 [ RunTime:0.003832s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047119 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198828,273109,142634,629411,464545,985940,547737,776519,633017,536425,928800,1011848,157766,793911,451773,220848,562122,370847,197619,831290,637200,450537,265318,8786,790181,1046332,991742,247221,973731,369703,572805,814703,58921,385461,73401,546200,316293,989761,12538,178639,695522,392735,127855,900587,698234,74484,742603,207850,374901,277853,217668,740438,650140,101946,314952,20190,769154,477102,35465,21218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]