SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514427 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514427 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702083,518269,783198,380324,217495,809398,225570,669175,925914,229792,570322,535788,1008367,5324,673956,923400,968801,492275,587484,50882,991717,742517,105507,219861,843022,123554,688700,765329,420996,140690,355886,322318,79718,481315,749595,843918,495799,894335,404298,578981,707830,160500,795448,159967,96840,776954,119429,303434,1021399,665082,820788,956686,60155,580712,704595,262723,948706,938161,151646,488499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]