SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445057 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445057 [ RunTime:0.003789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107774,545679,128056,1001651,229073,321603,725828,708332,852579,572943,488997,188795,567857,394771,751376,586224,1018092,337777,30578,629992,70078,809038,821427,104172,358553,668538,698353,952727,502662,413580,183973,746220,595018,667688,492561,553050,80493,233798,556647,835573,751064,270093,52981,180514,643645,727616,15624,631232,625889,126921,192622,419157,767651,258640,84416,353128,330723,501072,840310,107345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]