SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039328 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039328 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112953,421066,744486,623025,203328,962512,121418,538308,478308,807940,503402,718766,758433,164739,795069,462650,851682,298374,689485,918005,307633,551263,750166,786139,65538,190437,71277,981784,163744,607210,721146,707276,649418,513280,798032,969281,349399,803365,1022069,252291,883314,286636,431948,570133,690370,236222,861293,330778,611691,663349,779121,554724,864363,895265,192007,667445,1022120,457709,74514,934702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001077s ]