SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412618 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412618 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502494,520996,561164,1035507,450458,133140,93741,760476,919944,631012,368675,105535,670753,818682,1008578,453759,175883,163151,513337,389278,648372,591915,10305,449583,631003,448653,434359,896128,385049,1033227,397300,908992,644496,776143,225280,752838,838122,313502,956819,1005073,687879,281546,869639,673264,267067,952871,591423,964430,884332,706585,274604,436304,63545,698939,928307,749002,476855,173509,822391,580226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003243s ]