SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046626 LIMIT 1 [ RunTime:0.001131s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046626 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776769,129714,297203,761613,295504,825542,850171,3797,952075,602495,338846,264244,693893,916462,42496,352097,609141,466253,536675,700174,493205,582248,952148,555170,722214,839612,596281,377473,410704,103989,537493,144183,926717,339405,584462,1020520,415176,1012424,401279,765703,529812,305950,719227,352720,736898,973201,637774,908489,205317,419372,555510,344085,134547,627174,897027,381655,722608,508636,725861,597536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001574s ]