SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002974s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507081 LIMIT 1 [ RunTime:0.002218s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507081 [ RunTime:0.005717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373538,703280,724265,819914,717332,851584,423755,671813,555661,583853,779852,392620,472876,476794,236706,105507,967077,350717,1035037,34733,740721,877711,291818,880494,378841,795003,49223,122444,776387,182487,642067,34693,257057,626639,287276,215297,1036510,702727,585989,164239,739319,471454,559049,886324,533507,262809,994164,127416,523651,485708,270002,1044612,152374,1044877,13536,348427,28932,630511,55298,818841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001463s ]