SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490250 LIMIT 1 [ RunTime:0.001098s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490250 [ RunTime:0.005281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602720,5032,511658,168137,615558,552762,578213,627077,976253,344830,623406,20618,704933,213435,448154,603945,130197,693174,233533,187487,456338,293433,1039263,653738,102118,652965,33752,104979,990990,68635,398855,370665,560680,447810,82014,202288,50987,514974,809034,78480,766138,354970,847679,541270,729789,382472,231244,394175,970508,1047904,720137,500429,475789,309904,521700,1042927,767673,417002,1005540,205873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]