SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005213 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005213 [ RunTime:0.003447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26790,119292,693606,8011,455255,206053,816715,74452,615973,975587,881711,926972,518000,101337,280664,856440,85957,915334,518622,451882,128086,850358,215102,589994,169345,927586,752995,899403,436036,704840,265683,513890,127519,964194,707931,210453,687626,98129,736498,554221,776950,190424,647145,475397,380024,811126,994143,172896,408856,880219,876542,574287,3079,71807,60421,5479,399102,730896,716615,843069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]