SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54552 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54552 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779522,542848,243580,520646,670665,175156,771698,269535,571896,248436,821534,62541,973777,779169,283891,586405,981141,591067,183489,274540,728271,760131,471862,973517,983010,343169,760650,243811,563972,520233,1015136,819452,65015,607083,825830,473998,177568,786080,69562,733372,266842,62620,708053,597498,366828,672290,4005,425678,146300,401529,372243,262549,707757,301218,658381,328432,630474,282364,311812,186639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]