SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451974 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451974 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435655,910772,571325,177964,135024,379733,306017,389411,114013,872008,767885,666948,85408,94824,438851,406789,921275,785031,349155,170450,598379,155480,956011,626537,508512,844848,1026708,475985,117039,487691,783481,1010804,450606,120170,229532,94756,993172,606051,952440,120796,365391,243893,630528,1005073,865237,251116,636159,718215,27384,177988,24434,359019,467130,176040,961937,14265,901362,334390,861525,1028655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000905s ]