SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38864 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38864 [ RunTime:0.002815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794415,385823,557924,635479,813808,176320,340175,1029386,180119,816021,565550,739116,77127,964927,885035,291629,968154,166611,663046,948133,728940,887442,874863,526404,1014300,161814,465688,127352,800245,469088,577581,721537,579187,286410,604870,195862,659635,977352,991363,898088,6223,391821,11384,1047815,646788,505765,304677,609110,926104,293496,798285,162441,321104,822399,10561,718883,407020,92218,1036752,918038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]