SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549773 LIMIT 1 [ RunTime:0.000609s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549773 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605887,449579,751049,1006101,104482,922445,833601,400453,59543,474938,973987,712895,705818,631155,335621,189247,383552,462981,954563,900716,889327,149871,85542,836,658230,479052,184402,1026392,445333,1009495,634509,40153,913001,797800,319436,966825,523120,1013323,112718,367265,708125,666465,527271,310363,825468,170273,943916,348471,498341,771161,715705,478105,665330,483952,559107,65878,87198,248951,682929,375274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002434s ]