SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422684 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422684 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265062,262070,778845,596517,916945,11300,665317,61192,226664,550779,951236,221964,302210,878224,412211,505979,317971,732903,836650,428230,61057,407779,371160,572279,801200,1046386,337084,331678,930237,412139,1005572,867946,414172,839497,377347,974438,86258,848827,753820,994870,921994,484086,681965,37126,116609,1030222,926043,426726,340638,744782,771590,827485,451142,619986,247756,109474,472041,823817,131555,420304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]