SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034082 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034082 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937812,678446,547023,574745,814618,906297,998578,799329,288041,504640,922756,901226,937944,801302,741959,109530,781822,238257,976404,238496,612225,199851,1023421,308785,70697,595588,455218,929196,941005,943250,443691,401900,721788,645695,118066,578105,500584,780704,252960,377533,4374,1018802,546226,984683,146504,650904,225428,722808,122825,688900,95376,790115,104990,584066,371671,238479,550942,909655,226839,189010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]