SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450217 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450217 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148808,448031,556772,179100,562347,71318,1042515,524850,786016,1043380,948066,557963,663478,988626,1003381,365101,14491,417487,66396,430645,192816,134971,1025988,834536,375152,510204,435940,171299,1045873,899880,425154,818443,471354,554346,14941,520690,787897,147577,575930,978975,422198,211910,800103,61113,363218,411950,1047170,371990,65475,412492,849880,814220,348481,692521,316060,406562,816296,1032656,513532,949316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001915s ]