SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121712 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121712 [ RunTime:0.002355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295001,502811,546475,501960,373805,407621,1007146,769880,403057,1010207,321592,521936,442009,682654,191514,856987,50433,391472,710225,199867,5511,516051,612625,883132,453030,157109,121014,1000082,41937,826797,497935,121903,66360,701289,23331,20402,80278,330698,874695,861222,152325,53928,589766,329538,428609,375094,141402,744307,925575,667544,942660,1017389,361737,774585,876528,266330,275971,45155,634170,1023144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]