SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374407 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374407 [ RunTime:0.005468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222416,478081,1006309,1000731,660402,942183,450041,483376,455103,1032378,594523,152163,104635,838907,720350,613609,105143,331224,545586,398828,713174,70647,781258,400081,871198,333924,303371,294790,816478,924020,965435,598057,728846,330689,13533,784326,488411,880711,964442,188206,671483,424931,255547,27334,507420,560290,868034,369840,1038790,915157,975515,1024817,558888,464719,519700,99143,753516,49016,512363,765056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 374407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 374407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]