SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822890 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822890 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801658,136521,560931,801615,822850,814407,735110,297713,11011,89978,653813,578128,1041092,91792,913965,654145,102687,369604,923682,895213,600873,1018613,419293,258957,830042,19598,565359,167513,48314,455579,74315,68883,405654,765684,150406,508283,671099,1009518,626149,193419,120200,199113,589524,391776,310812,71864,612426,150967,829473,452392,547519,230488,318352,957174,99434,679345,867350,476098,610552,1022187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001831s ]