SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505272 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505272 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315717,770333,412349,487935,357592,420133,1012585,930741,530808,937893,787905,940032,811270,7748,596172,760651,1017951,411793,1042514,133774,84666,1033224,472298,63634,1003893,639471,867864,150671,63682,814152,653592,163667,993934,407039,596623,892909,239624,395173,44994,169154,270584,1005198,841255,17463,231261,7355,1025652,978621,188344,209024,345099,943611,492836,122897,138860,677149,88114,287833,56638,88023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]