SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006691 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006691 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893321,622676,382886,1020619,574062,303384,664979,357799,694303,958571,700088,199722,345304,914413,724788,147813,607004,908626,32603,1043532,340492,105793,133553,155677,420659,902845,678592,205579,926561,571628,219234,838233,1022946,711635,510286,871206,866748,900070,247294,835746,761806,813842,630557,739564,656263,323335,69086,988919,1021668,228977,577468,298610,36505,91592,113539,990827,775612,870401,954407,238787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]