SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526834 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526834 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788275,212979,242653,920295,367564,552030,157719,87957,418917,997322,737476,221830,518916,1029335,360236,87416,765769,163901,618037,516195,891782,156250,118877,990337,756585,835464,57348,69926,402391,723224,469188,445845,949568,610909,677540,352257,41397,975465,863580,131307,512837,70626,501857,44440,304008,70409,461486,158026,904683,27326,889168,182777,758241,122662,195944,822984,895543,941421,49712,237440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]