SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 90213 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 90213 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599845,532029,1037430,578942,242386,664319,878508,528191,729381,335690,487977,600772,40227,161990,625270,749736,550512,850419,821887,944364,884328,32855,507734,580173,406879,395387,340147,73126,33300,823418,761931,342649,780121,882934,576928,912080,368853,613395,215563,89352,697760,37167,367408,1027170,382993,573641,295352,763280,602643,51593,226379,764057,713408,246502,346576,246554,206369,879010,804769,568891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 90213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 90213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001298s ]