SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101864 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101864 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002612,543556,839242,279710,599850,534123,402506,199982,642276,112436,1030281,659898,1010861,948340,533073,345191,35622,222978,758230,841310,30050,1003293,789878,372840,999447,90228,496192,605257,935098,439811,13693,361390,60866,807537,430315,316381,922006,595212,447134,58699,624503,972381,271371,996210,233946,909983,426456,367256,276082,490800,646536,485007,793607,710915,149486,816837,1019526,113394,635346,963753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]