SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009438 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009438 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610033,217749,1012855,986172,828659,362649,738556,639450,280533,820938,489302,470171,919979,193950,779341,1011049,18163,81288,720760,14578,930468,1014456,504386,870940,861629,331721,734449,536789,764562,832855,998132,516090,555600,291330,700521,527745,204544,408880,278040,650491,349442,701748,852681,226446,108846,156208,202990,667255,811568,790850,792946,562884,702729,893180,550867,308012,148194,142233,21554,487622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005514s ]