SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437813 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437813 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63450,881747,127887,557099,945453,526299,437656,728927,816711,235737,449638,376619,612924,830757,875433,400736,507598,175283,1024205,596191,858584,962043,37682,494824,717589,5233,130852,244662,818564,51277,241965,669079,494830,363220,862271,353797,242311,169846,674597,427726,142085,460687,99734,573095,979564,811262,1000924,850482,667230,83608,142629,870566,154824,44324,302915,912790,38727,406693,873658,347975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]