SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023632 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023632 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352115,249899,38728,562704,828841,437940,859189,144412,690008,989237,481560,914495,506802,446033,698131,488349,349307,185760,298039,720751,648285,964847,593407,974233,527078,265350,55878,291344,649678,394799,144679,382135,536970,410228,286124,220769,994083,188906,150851,742198,449518,923913,120242,754974,915468,45879,476055,404354,546771,929370,238262,406457,660334,242349,780492,377778,24464,144066,208073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023632 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023632 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000914s ]