SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548085 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548085 [ RunTime:0.002675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27379,631582,958658,420755,962080,373592,322233,108872,733429,858560,206129,583509,1026419,995350,142818,865817,551855,965337,1006960,457654,73247,927723,917154,937711,913438,226348,941338,1012987,430703,150052,808402,395317,831516,714495,774542,862701,567116,758216,601631,698397,486283,196266,50849,729292,154464,264796,810847,152432,386583,165729,422543,578344,230763,922741,450790,840498,36839,314236,493015,987752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]