SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023609 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023609 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112558,763640,648052,920996,503016,778412,541366,872247,458216,845343,275524,957294,960371,74508,623299,692916,716841,524431,688736,770092,23313,664987,583093,844623,984204,248531,321028,730649,627189,858238,89152,117269,122468,981568,553271,180945,675249,102797,75098,788386,117719,202776,68800,50647,1036774,879672,666751,43428,822462,813017,784855,157341,353395,312008,834664,237417,774163,860384,68727,854022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]