SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200985 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200985 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619486,48954,662457,412900,1034408,346764,881440,256439,167613,997367,117305,544824,17188,611188,902267,543898,249478,240709,682455,339032,136519,390629,460206,629368,672850,105545,662404,701608,404468,971147,1029235,395129,115355,60241,239058,120683,150504,583636,81074,719084,614485,700896,173684,376762,359707,484431,947242,154196,825424,951201,302464,396406,532861,913682,69839,707447,319383,946053,564568,11285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]