SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522701 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522701 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398104,835244,71856,457066,375619,776868,912660,863744,835937,234127,563677,806729,475710,450673,600234,747893,732985,247130,520516,163661,221778,633659,1009185,258277,112844,646079,695416,930148,846696,452963,936138,354397,174284,288871,888013,278594,377948,544857,1047343,381114,389667,448661,275193,732000,468176,653603,757732,359249,738364,913827,240678,720000,671896,795000,522228,208438,540410,507787,496427,496929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]