SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502341 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502341 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956472,874233,363954,625437,751781,854346,394550,372901,200460,874059,297675,12614,706960,366463,22303,640057,901954,736882,536824,463248,892175,92419,765406,166585,817887,12402,180575,550540,77241,330849,214959,660469,394381,305155,417242,127416,610123,921056,437851,620476,1045079,669225,527472,375599,745935,1404,144707,881701,450090,282248,214531,41284,786393,191175,919786,433407,288911,607850,732394,817409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]